09. SQL to SQL ETL - AWS Case

L03-04-Part 2 SQL To SQL ETL - AWS Case

In the ETL implementation on AWS, what is the purpose of the EC2 instance?
SOLUTION: Just a machine that acts as a client to RDS and Redshift to issue COPY commands

Which of the following is an advantage of using S3 for ETL storage? (Compared to storing the data in our own EC2 instance)
SOLUTION:
  • S3 is AWS-managed, we don't need to worry about storage reliability
  • By using S3, we only pay for the storage we use
  • By using S3, we don't need to worry about not having enough storage

Next Concept